Method and system for processing electronic table data based on time sequence

ABSTRACT

A method for processing electronic table data based on a time sequence comprises: after receiving processing request information for calculating a data object with a time attribute, reading basic period information in an electronic table, calculating result data according to calculation manner information in the processing request information, and determining a basic period contained in each calculation result data and a writing position of the calculation result data in the electronic table; and generating a computing formula for calculating the basic period contained in the calculation result data, calculating the data object by using the computing formula, and writing the calculation result data generated after calculation into the electronic table according to a requirement of the processing request information. A system for processing electronic table data based on a time sequence comprises: a position determination module and a calculation module.

CROSS-REFERENCE TO RELATED APPLICATIONS

This application is a continuation of International Application No.PCT/CN2007/000948, filed on Mar. 23, 2007, which claims the prioritybenefit of China Patent Application No. 200610065597.3, filed on Mar.24, 2006. The contents of the above identified applications areincorporated herein by reference in their entirety.

FIELD OF THE TECHNOLOGY

The present invention relates to a method and a system for processingelectronic table data based on a time sequence, particularly to a methodand a system for performing calculation on data objects with timeattributes in an electronic table by using time regularity.

BACKGROUND OF THE INVENTION

Currently, in practical applications of various fields such as commerce,life, scientific research and so on, it is always needed to performdivision and calculation on the data objects with the time attributes inan electronic table according to time regularity. For example, acompany's fiscal expenditure condition per month from 2001 to 2005 isrecorded in an electronic table. At this time, the data objectindicating the fiscal expenditure condition of a month owns a timeattribute. If someone wants to know the company's fiscal expenditurecondition per quarter during these 5 years, it is needed to divide andsummarize the data objects in the electronic table based on the quarter.In prior art, a user is not able to use the time regularity forprocessing the data objects with the time attributes correspondingly.The user can only manually set needed data and computing formula. Then,the user manually fills the data and computing formula into theelectronic table. The user has to do a lot of cumbersome repeatabilityoperations manually because the data amount of the data objects to beprocessed is usually quite enormous, which not only wastes the user'stime and energy, but also causes low work efficiency and high errorrate.

SUMMARY OF THE INVENTION

With regard to the defects and shortcomings in prior art that it isimpossible to use the time regularity to calculate the data object withthe time attribute in the electronic table, the object of the presentinvention is to provide a method and a system for processing electronictable data based on a time sequence. The method can use the timeregularity to divide and calculate the data object with the timeattribute in the electronic table so as to avoid user's cumbersomeoperation, improving the work efficiency and reducing the error rate.The system can be used to implement the method for processing electronictable data based on a time sequence.

In order to implement the above-mentioned object, the present inventionprovides a method for processing electronic table data. The methodcomprises the following steps;

-   -   step 1, after receiving processing request information for        calculating a data object with a time attribute, reading basic        period information in an electronic table, calculating result        data according to calculation manner information in the        processing request information, and determining a basic period        contained in each calculation result data and a writing position        of the calculation result data into the electronic table; and    -   step 2, generating a computing formula for calculating the basic        period contained in the calculation result data, calculating the        data object by using the computing formula, and writing the        calculation result data generated after calculation into the        electronic table according to a requirement of the processing        request information.

In the above technical solution, before the step 1, the method furthercomprises:

-   -   step A, writing item information, the data object of an item and        the basic period information into the electronic table, wherein        the item information comprises item name information and address        information of a start cell where the item information is        located, and the basic period information comprises information        of a period type, the number of periods and a start time; and    -   step B, sending the processing request information for        calculating the data object to the application program, wherein        the processing request information carries the calculation        manner information and writing position information of the        calculation result data obtained after calculation.

The step of writing the item information into the electronic table inthe step A comprises:

-   -   step A11, sending request information for writing the item        information into the electronic table to the application        program, wherein the item information comprises item name        information and the address information of the start cell where        the item information is located; and    -   step A12, the application program writes the item information        into a system table; at the same time, calculates a cell address        of the item name information according to start cell address        information; and then, writes the item name information into the        cell corresponding to the calculated cell address.

The step of writing basic period information into the electronic tablein the step A specifically comprises:

-   -   step A21, sending request information for writing the basic        period information into the electronic table to the application        program, wherein the basic period information comprises        information of a period type, the number of periods and a start        time;    -   step A22, the application program, according to the information        of the period type, the number of periods and the start time,        calculates a time interval of each basic period, calculates a        column number of the cell of the electronic table into which        each time interval should be written, and generates the        corresponding time interval information according to each time        interval and the corresponding column number; and    -   step A23, the application program writes the time interval and        the corresponding column number information into the system        table; at the same time, writes the time interval information        into the cell corresponding to the column number and in a line        corresponding to a start cell address.

It can be seen from the above-mentioned technical solutions that, whenwriting the data object with the time attribute into the electronictable, the present invention also writes item information and basicperiod information. In this way, when processing the data object, theuser only needs to designate a writing position where the calculationmanner and the calculation result data of the data object in theelectronic table are written into the electronic table, so that thesystem can automatically calculate the data objects in a belonged periodaccording to the calculation manner. The operation is simple so as toimprove the work efficiency, reduce the error rate and greatlyfacilitate the users.

In order to implement the above-mentioned subject, the present inventionfurther provides a system for processing electronic table data based ona time sequence. The system comprises a position determination moduleand a calculation module. The position determination module is adaptedto read basic period information in an electronic table, calculateresult data and determine a basic period contained in each calculationresult data and a writing position of the calculation result data in theelectronic table. The calculation module is adapted to generate acomputing formula for calculating the basic period contained in thecalculation result data, calculate the data object by using thecomputing formula, and write the calculation result data generated aftercalculation into the electronic table.

The position determination module in above-mentioned system determinesthe basic period and the writing position in the electronic table. Thecalculation module writes the calculation result data into theelectronic table. The method for processing electronic table data basedon a time sequence according to the present invention is implemented.

The present invention will be described in more detail with reference tothe drawings and embodiments.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a flow chart illustrating the method for processing electronictable data based on a time sequence according to an embodiment of thepresent invention;

FIG. 2 is a flow chart illustrating the method for processing electronictable data based on a time sequence according to another embodiment ofthe present invention;

FIG. 3 is a flow chart of writing item information according to thepresent invention;

FIG. 4 is a flow chart of writing basic period information according tothe present invention.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

As shown in FIG. 1, it is a flow chart illustrating the method forprocessing electronic table data based on a time sequence according toan embodiment of the present invention. The method comprises thefollowing steps:

Step 1, when an application program receives processing requestinformation for calculating the data objects with the time attributes,the application program reads all the basic period informationpre-written into the electronic table and determines the periodcontained in each calculation result data and the writing position ofthe calculation result data into the electronic table according to thecalculation manner information in the processing request information.For example, when the application program receives the processingrequest information for summarizing the data objects indicating the“income” in each month of 2005 based on a quarter, the applicationprogram reads the basic period information in the electronic table anddetermines that the basic period which should be contained in the firstquarter of 2005 is January, 2005, February, 2005 and March, 2005. If itis defined that the writing position of each quarter's calculationresult data obtained after calculation is behind the basic periodcontained in each quarter, it is needed to write the income data of thefirst quarter of 2005 obtained by calculation into the column behind thecell where the data object indicating “income” in March, 2005 in theelectronic table is located. In a similar way, the income data of thesecond quarter of 2005 obtained by calculation is written into thecolumn behind the cell where the data object indicating “income” inJune, 2005 in the electronic table is located. The rest may be deducedby analogy.

In order to facilitate the user's observation and enable the user toknow the signification of each calculation result data clearly, it isalso needed to determine the title name of the calculation result datagenerated according to the calculation manner information and write intothe corresponding position in the electronic table. For example, if acounting manner is defined as counting based on the quarter, the tilename of the calculation result data in the first quarter of 2005 will be“the first quarter of 2005” or “Quarter 1/2005”. If it is defined thatthe writing position of the calculation result data in each quarterobtained after calculation is behind the basic period contained in eachquarter, it is needed to write the title name into the column behind thebasic period “March, 2005” in the electronic table.

Step 2, the application program generates a computing formula forcalculating the basic periods contained in each calculation result data,uses the computing formula to calculate the data object, and writes thecalculation result data generated after calculation into thecorresponding position in the electronic table according to requirementof the processing request information. For example, if it is definedthat the counting manner is to count based on a quarter, the start timeis January, 2005, and the item name to be calculated is “income”, eachcomputing formula may indicate as: sum (income (January, 2005; February,2005; March, 2005)), sum (income (April, 2005; May, 2005; June, 2005)),. . . , etc., and these computing formulae may be used to summarize thedata objects indicating “income” corresponding to the basic periods(e.g. “January, 2005”, “February, 2005” and “March, 2005” contained inthe first quarter of 2005) contained in each quarter. And thecalculation result data of each quarter obtained by summarization isrespectively written into the cell behind the cell where the item dataof the last period contained in each quarter is located. For example,the calculation result data of “income” in “the first quarter of 2005”,“the second quarter of 2005”, “the third quarter of 2005”, and “thefourth quarter of 2005” are respectively written into the cell behindthe cell where the data object indicating “income” in “March, 2005”,“June, 2005”, “September, 2005”, and “December, 2005” is located.

In the step 2, during calculating the data object by using the computingformula, in order to facilitate the application program to identify thecomputing formula, the item name information and the period informationin the computing formula may be transformed into electronic tableaddress information. For example, the period information in thecomputing formula is transformed into the column number informationwhere the period is located, and the item name information istransformed into the line number information where the item name islocated. Then, the line number and the column number information aretransformed into the electronic table address information. According tothe address information, the computing formula is transformed into anelectronic table formula indicated by cell address information. Theelectronic table formula is used to calculate the item data. Forexample, if the item name of “income” is at Line 2 and the periods of“January, 2005”, “February, 2005” and “March, 2005” are at Column 2, 3and 4 respectively, the “income”, “January, 2005”, “February, 2005” and“March, 2005” in the computing formula of sum (income(January, 2005,February, 2005, March, 2005)) are transformed into cell addresses of A2,B1, C1 and D1 and an electronic table formula of “=sum (B1, C1, D1)” isgenerated, i.e. the data at Column 2, 3 and 4 in Line 2 are calculated.

FIG. 2 is a flow chart illustrating the method for processing theelectronic table data based on a time sequence according to anotherembodiment of the present invention. In the present embodiment, thesteps are added before the step 1 in the previous embodiment as follows;

Step A, item information, the data object of the item and the basicperiod information are written into the electronic table. The iteminformation comprises the information such as an item name (e.g.“income”, “expenditure”) information and a start cell address (e.g. Line1, Column 2) of the item information and so on. The basic periodinformation comprises the information such as a period type (e.g. year,month, week and so on), the number of periods (i.e. how many periods aredefined) and the start time (e.g. January, 2005) and so on.

Step B, the processing request information for calculating the dataobject is sent to the application program. The processing requestinformation carries calculation manner information and writing positioninformation of the calculation result data obtained after calculation.For example, request information is sent to the application programafter counting the data objects in the item of “income” based on thequarter and writing respectively the calculation result data of eachquarter obtained after counting into the period contained in eachquarter.

During writing the data object with a time attribute into the electronictable, the item information and the basic period information are alsowritten so that it is convenient to establish mutual relationship amongthe three according to the cell addresses of the three. The user onlyneeds to designate the data object needed to be calculated and thecalculation manner, and then the application program may use the timeregularity to automatically divide and calculate the data objectaccording to the calculation manner acquired by the user without user'smanual calculation one by one, which simplifies the user's operationflow, at the same time, improves the work efficiency, reducesinformation manual input and error rate, and facilitates the user.

In the step A, there is no limitation for order of writing the iteminformation, the data object and the basic period information into theelectronic table. All the above information may be written at the sametime or any one or two pieces of information may be written at first.The operation of writing the item information into the electronic tablemay be implemented according to the flow shown in FIG. 3 as follows;

Step A11, the user sends request information for writing the iteminformation into the cell of the electronic table to the applicationprogram through a client. The item information comprises the item name,e.g. “income”, “expenditure” information, and the start cell address ofthe item information, e.g. the information of Line 1, Column 2.Certainly, for the sake of convenience in the future, the user may alsoadd other information into the item information such as type (e.g.currency) information of the data object, length information of the dataobject, format information of the data object, and formula informationof the data object, e.g. “income−expenditure”.

Step A12, the application program writes the item information and thestart cell address information into the system table; at the same time,calculates the cell address of the item name information according tothe start cell address; and then writes the item name information intothe cell corresponding to the cell address.

The method for calculating the cell address of the item name informationmay specifically comprise: adding 1 to the line number in the start celladdress so as to obtain the cell address of the item name information.For example, the start cell address is Line 1, Column 2, and the itemname information of “income” is written into the cell of Line 2, Column2.

In the step A11, the user may also configure a default value for thedata object in the item information. After configuring the data object,the application program may write the configured default value at thecell where the line in which the item name information is locatedintersects the column in which the basic period information is located.The specific number of columns may be determined according to the numberof periods configured by the user, that is, the number of periods isdefined in the above-mentioned step 1. For example, the cell addresswhere the item name information of “income” is located is Line 2, Column2 and the default value configured for the “income” in each period is1000 so that a data “1000” is written into the cell corresponding to thecolumn where all the basic periods are located in Line 2 of theelectronic table. The specific number of columns which are written intois determined and configured by the user. In the same one item, if thedata of “income” in most periods are the same, the default number may beconfigured when the item information is defined so that the applicationprogram may automatically input data of each period for the user withoutinputting one by one by the user, which simplifies the user's operationflow and facilitates the user.

Between the step A11 and the step A12, the application program furtherverifies whether the item information input by the user is right. If itis right, the step A12 is executed; otherwise, the operation ends. Forexample, the application program judges whether the item informationcontains a formula. If it contains the formula, the application programjudges whether the formula is right. Specifically, the applicationprogram may judge whether the formula is right by judging the fieldquoted whether existing by the formula. For example, when the formula is“income-expenditure”, the application program may resolve the formulainto an “income” and “expenditure” field and inquire whether the“income” and “expenditure” field exists in the system table. If itexists, it is indicated that the formula is right, i.e. the iteminformation input by the use is right, so the step A12 is executed;otherwise, it is indicated that the item information input by the useris wrong, so the application program will not write the item informationand the start cell address information into the system table. In thisway, it prevents the user from inputting wrong information in time,avoids the consumption of system resources caused by processing thewrong information by the application program and avoids the waste of theuser's time and energy because of unnecessary follow-up operations.

Between the step A and the step B, the application program furtherjudges whether a basic period information exists in the system table. Ifno basic period information exists, the operation ends; otherwise, theapplication program further judges whether a formula is contained in theitem information. If no formula is contained, the step B is executed;otherwise, the application program resolves the formula. If the formulacontains an item name, the application program obtains the line numberof the item name in the electronic table and the column number of eachbasic period in the electronic table. The application program generatesthe corresponding cell address respectively according to the line numberand each column number, substitutes the corresponding item name in theformula with the cell address, and writes the new formula generatedafter substitution into the cell where the line in which the item namecontaining the formula is located intersects the column respectively inwhich each basic period is located. For example, the item information“profit” contains a formula “income−expenditure”; the line number of theitem information “income” in the electronic table is 2, the line numberof the item information “expenditure” in the electronic table is 3; theline number of the item information “profit” in the electronic table is4; and the column numbers where the basic periods “January, 2005”,“February, 2005” and “March, 2005” are located are 2, 3, and 4respectively. The new formulae generated for the basic periods “January,2005”, “February, 2005” and “March, 2005” are “=B2−B3”, “=C2−C3” and“=D2−D3” respectively. The three formulae are respectively written intothe cell in which the addresses are B4, C4 and D4 in the electronictable.

In addition, between the step A and the step B, through a clientoperation interface, the step of writing the calculation mannerinformation for calculating the data object in the electronic table andthe writing position information of the calculation result data obtainedafter calculation is further executed.

As shown in FIG. 4, it illustrates a specific flow of writing the basicperiod information into the electronic table according to the presentinvention. It comprises the following steps:

Step 401, a user sends request information for writing basic periodinformation into the electronic table to the application program througha client. The basic period information comprises information of a periodtype such as day, week, month, quarter and year, the number of periods,and a start time of an item such as January, 2005;

Step 402, the application program calculates the time interval of eachperiod according to the information of period type, the number ofperiods and the start time. For example, under the situation that theperiod type is quarter, the start time is Jan. 1, 2005, for the periodtype is quarter and the time interval of adjacent period is 3 months,the time interval of each period of the item is obtained by adding 3months in turn based on the start time of Jan. 1, 2005 respectively.When the number of periods is 3, each period of the item is Jan. 1,2005, Apr. 1, 2005, Jul. 1, 2005 respectively;

Step 403, the application program judges whether the item informationexists in the electronic table, if no item information exists, a step404 is executed; otherwise, a step 405 is executed;

Step 404, the application program calculates the column number of thecell where each time interval needs to be written into the electronictable respectively according to the cell address where the current focusis located, generates the corresponding time interval informationaccording to each time interval and the corresponding column numberthereof, and then writes the time interval information into the systemtable, and at the same time, also writes each time interval informationsuch as Jan. 1, 2005, Apr. 1, 2005 and Jul. 1, 2005 respectively intothe corresponding cell. After that, a step 406 is executed;

Step 405, the application program calculates the column number of thecell where each time interval needs to be written into the electronictable respectively according to the start cell address of the iteminformation, generates the corresponding time interval informationaccording to each time interval and the corresponding column numberthereof, writes each time interval information into the system table,and at the same time, writes the time interval information such as Jan.1, 2005, Apr. 1, 2005 and Jul. 1, 2005 respectively into thecorresponding cell;

Step 406, the end.

In the step 404 and 405, when the application program calculates thecolumn number of the cell where each time interval needs to be writteninto the electronic table respectively, the application program mayspecifically performs the calculation in the following manners: adding 1to the column number of the start cell address or the cell address wherethe current focus is located to obtain the cell address of the firstperiod; adding 1 to the column number of the cell address of the firstperiod to obtain the cell address of the second period; deducing byanalogy similarly, adding n (n is a integer greater than 0) to thecolumn number of the start cell address or the cell address where thecurrent focus is located obtain the cell address of the nth period. Forexample, a start cell address of the item information is Line 1, Column2; from the beginning of the first period, the cell addresses of theitem information of each period are: Line 1, Column 3; Line 1, Column 4;Line 1, Column 5, . . . , and so on in turn, i.e. the column numbersare: Column 3, Column 4, Column 5, . . . , and so on in turn. Accordingto the example in the step 112, “Jan. 1, 2005”, “Apr. 1, 2005” and “Jul.1, 2005” are written at Line 1, Column 3; Line 1, Column 4; and Line 1,Column 5 respectively.

Between the step 405 and the step B, the application program furtherjudges whether item information exists in the system table. If no iteminformation exists, the operation ends; otherwise, the applicationprogram further judges whether item name information containing formulaexists. If no item name information containing formula exists, the stepB is executed; otherwise, the application program resolves the formula.If the formula contains an item name, the application program obtainsthe line number of the item name in the electronic table and the columnnumber of each basic period in the electronic table. The applicationprogram generates the corresponding cell address respectively accordingto the line number and each column number, substitutes the correspondingitem name in the formula with the cell address, and writes the newformula generated after substitution into the cell where the line inwhich the item name containing the formula is located intersects thecolumn respectively in which each basic period is located.

In the above embodiments, the user may modify the item information inthe electronic table. When the application program receives new iteminformation input by the user, it may substitute the original iteminformation with the new item information and substitute the originalitem name in the electronic table with the new item name at the sametime. If the insertion position of the item information is modified, theitem name will be moved to the new position and at the same time, allthe data on the line where the item name is located will be moved to theline of the new position where the item name is located with the columnnumber of each item data keeping the same. After that, the applicationprogram further judges whether another item name in the item informationquotes the item name modified, i.e. whether the item name indicated by aformula contains a modified item name. If it does not quotes, theoperation ends; otherwise, the application program substitutes theoriginal item name with the new item name and writes the new formulagenerated after substitution into the system table and the electronictable.

A system for processing electronic table data based on a time sequencecomprises a position determination module and a calculation module.After the position determination module receives processing requestinformation for calculating a data object with a time attribute, theposition determination module reads basic period information in theelectronic table, calculates result data according to the calculationmanner information in the processing request information, and determinesthe basic period contained in each calculation result data and thewriting position where the calculation result data is located in theelectronic table. The calculation module generates a computing formulafor calculating the basic period contained in the calculation resultdata, calculates the data object by using the computing formula, andwrites the calculation result data generated after calculation into theelectronic table according to the processing request information.

The system may further comprise a writing module and a sending module.The writing module writes the item information, the data object of theitem and the basic period information into the electronic table. Theitem information comprises item name information and the addressinformation of the start cell where the item information is located. Thebasic period information comprises the information of the period type,the number of periods and the start time. The sending module sendsprocessing request information for calculating the data object. Theprocessing request information carries the calculation mannerinformation and the writing position information of the calculationresult data obtained after calculation.

The above-mentioned writing module may comprise an item informationrequest writing module and an item information writing module. The iteminformation request writing module sends request information for writingitem information into the electronic table. The item informationcomprises item name information and address information of the startcell where the item information is located. The item information writingmodule writes the item information into the system table according tothe request information sent by the item information request writingmodule, calculates the cell address of the item name information in theitem information, and writes the item name information into the cellcorresponding to the calculated cell address.

The above-mentioned writing module may further comprise a basic periodrequest writing module, a time interval calculation module and a timeinterval writing module. The basic period request writing module sendsrequest information for writing basic period information into theelectronic table. The basic period information comprises the informationof the period type, the number of periods and the start time. The timeinterval calculation module, according to the information of the periodtype, the number of periods and the start time in the requestinformation sent by the basic period request writing module, calculatesthe time interval of each basic period, and calculates the column numberof the cell of the electronic table into which each time interval shouldbe written. The time interval writing module writes the time intervaland the corresponding column number information calculated by the timeinterval calculation module into the system table and writes the timeinterval information into the cell corresponding to the column number inthe line corresponding to the start cell address.

The above-mentioned time interval calculation module may comprise atable item information judgment module, a first column numbercalculation module and a second column number calculation module. Thetable item information judgment module judges whether item informationexists in the electronic table. If no item information exists, the firstcolumn number calculation module, according to the address of the cellwhere the current focus is located, calculates the column number of thecell of the electronic table into which the time interval should bewritten; otherwise, the second column number calculation modulecalculates the column number of the cell of the electronic table intowhich the time interval should be written according to the start celladdress.

Between the above writing module and the sending module, there may befurther provided with an item information judgment module, a formulajudgment module and a formula generating module. The item informationjudgment module judges whether item information exists in the systemtable. If the item information exists, the formula judgment modulejudges whether the item information contains a formula. If it contains aformula, the formula generating module resolves the formula contained inthe item information to be an item name, substitutes the cell addresswhere the line in which the item name is located intersects the columnrespectively in which each basic period is located into the formula togenerate a new formula, and writes the new formula into the celldetermined by the line where the item name containing the formula islocated and the column where each basic period is located.

Between the writing module and the sending module, it is furtherprovided with a calculation manner and position writing module. Thecalculation manner and position writing module writes the calculationmanner information for calculating the data object in the electronictable and the writing position information of the calculation resultdata obtained after calculation.

The above-mentioned calculation module may comprise a statistic module.The statistic module transforms the item name information and the periodinformation into electronic table address information, transforms thesummary formula into an electronic table formula indicated by celladdress information, and counts the item data.

The above-mentioned system for processing electronic table data based ona time sequence determines the writing position of the basic period andcalculation result contained by the calculation result in the electronictable through the position determination module. The calculation modulewrites the generated calculation result into the electronic table. Themethod for processing electronic table data based on a time sequenceaccording to the present invention is implemented by the system.

Finally, it should be understood that the above embodiments are onlyused to explain, but not to limit the technical solution of the presentinvention. In despite of the detailed description of the presentinvention with referring to above preferred embodiments, it should beunderstood that various modifications, changes or equivalentreplacements can be made by those skilled in the art without departingfrom the scope of the present invention and covered in the claims of thepresent invention.

1. A method for processing electronic table data based on a timesequence, comprising: step 1, after receiving processing requestinformation for calculating a data object with a time attribute, readingbasic period information in an electronic table, calculating result dataaccording to calculation manner information in the processing requestinformation, and determining a basic period contained in eachcalculation result data and a writing position of the calculation resultdata into the electronic table; and step 2, generating a computingformula for calculating the basic period contained in the calculationresult data, calculating the data object by using the computing formula,and writing the calculation result data generated after calculation intothe electronic table according to a requirement of the processingrequest information.
 2. The method according to claim 1, before the step1, further comprising: step A, writing item information, the data objectof an item and the basic period information into the electronic table,wherein the item information comprises item name information and addressinformation of a start cell where the item information is located, andthe basic period information comprises information of a period type, thenumber of periods and a start time; and step B, sending the processingrequest information for calculating the data object, wherein theprocessing request information carries the calculation mannerinformation and writing position information of the calculation resultdata obtained after calculation.
 3. The method according to claim 2,wherein the step of writing the item information into the electronictable in the step A comprises: step A11, sending request information forwriting the item information into the electronic table, wherein the iteminformation comprises item name information and the address informationof the start cell where the item information is located; and step A12,writing the item information into a system table; at the same time,calculating a cell address of the item name information according tostart cell address information; and then, writing the item nameinformation into the cell corresponding to the calculated cell address.4. The method according to claim 3, wherein the request information forwriting the item information in the step A11 further comprises therequest information for writing the data object of the item.
 5. Themethod according to claim 3, between the step A12 and the step B,further comprising: step A13, judging whether the basic periodinformation exists in the system table; executing a step A16 if no basicperiod information exists; otherwise, executing a step A14; step A14,judging whether a formula is included in the item information; executingthe step B if no formula is included; otherwise, executing a step A15;step A15, resolving the formula to be an item name, substituting thecell address where the line in which the item name is located andintersects the column respectively in which each basic period is locatedinto the formula to generate a new formula, and writing the new formulainto the cell determined by the line where the item name containing theformula is located and the column where each basic period is located;and step A16, ending.
 6. The method according to claim 2, wherein thestep of writing basic period information into the electronic table inthe step A specifically comprises: step A21, sending request informationfor writing the basic period information into the electronic table,wherein the basic period information comprises information of a periodtype, the number of periods and a start time; step A22, according to theinformation of the period type, the number of periods and the starttime, calculating a time interval of each basic period, calculating acolumn number of the cell of the electronic table into which each timeinterval should be written, and generating the corresponding timeinterval information according to each time interval and thecorresponding column number; and step A23, writing the time interval andthe corresponding column number information into the system table; atthe same time, writing the time interval information into the cellcorresponding to the column number and in a line corresponding to astart cell address.
 7. The method according to claim 6, wherein the stepof calculating the column number of the cell of the electronic tableinto which each time interval should be written in the step A22specifically comprises: step A221, judging whether the item informationexists in the electronic table; executing a step A222 if no iteminformation exists; otherwise, executing a step A223; step A222,calculating the column number of the cell of the electronic table intowhich the time interval should be written according to an address of thecell where a current focus is located; and step A223, calculating thecolumn number of the cell of the electronic table into which the timeinterval should be written according to the start cell address.
 8. Themethod according to claim 6, between the step A23 and the step B,further comprising: step A24, judging whether the item informationexists in the system table; executing a step A27 if no item informationexists; otherwise, executing a step A25; step A25, judging whether theitem information contains a formula; executing the step B if no formulais included; otherwise, executing a step A26; step A26, resolving theformula to be an item name, substituting the cell address where the linein which the item name is located intersects the column respectively inwhich each basic period is located into the formula to generate a newformula, and writing the new formula into the cell determined by theline where the item name containing the formula is located and thecolumn where each basic period is located; and step A27, ending.
 9. Themethod according to claim 2, between the step A and the step B, furthercomprising: writing the calculation manner information for calculatingthe data object into the electronic table and the writing positioninformation of the calculation result data obtained after calculation.10. The method according to claim 1, wherein the step 1 furthercomprises: generating a title name of the calculation result dataaccording to the calculation manner information in the processingrequest information and writing the title name into the electronictable.
 11. The method according to claim 1, wherein the step of usingthe computing formula to count the item data in the step 2 comprises:transforming the item name information and the basic period informationin the summary formula into electronic table address information;transforming the summary formula into an electronic table formulaindicated by cell address information according to the electronic tableaddress information; and counting the item data by using the electronictable formula.
 12. A system for processing electronic table data basedon a time sequence, comprising: a position determination module adaptedto read basic period information in an electronic table, calculateresult data and determine a basic period contained in each calculationresult data and a writing position of the calculation result data in theelectronic table; and a calculation module adapted to generate acomputing formula for calculating the basic period contained in thecalculation result data, calculate the data object by using thecomputing formula, and write the calculation result data generated aftercalculation into the electronic table.
 13. The system according to claim12, further comprising: a writing module adapted to write iteminformation, the data object of an item and the basic period informationinto the electronic table; a sending module adapted to send processingrequest information for calculating the data object.
 14. The systemaccording to claim 13, wherein the writing module comprises: an iteminformation request writing module adapted to send request informationfor writing the item information into the electronic table; and an iteminformation writing module adapted to write the item information into asystem table according to the request information sent by the iteminformation request writing module, calculate a cell address of an itemname information in the item information, and write the item nameinformation into the cell corresponding to the calculated cell address.15. The system according to claim 13, wherein the writing modulecomprises: a basic period request writing module adapted to send requestinformation for writing the basic period information into the electronictable; a time interval calculation module adapted to calculate the timeinterval of each basic period and the column number of the cell of theelectronic table into which each time interval should be writtenaccording to the request information sent by the basic period requestwriting module; and a time interval writing module adapted to write thetime interval information and the corresponding column numberinformation calculated by the time interval calculation module into asystem table, and write the time interval information into the cell. 16.The system according to claim 15, wherein the time interval calculationmodule comprises: a table item information judgment module adapted tojudge whether the item information exists in the electronic table; afirst column number calculation module adapted to calculate the columnnumber of the cell of the electronic table into which the time intervalshould be written according to a judgment result of the table iteminformation judgment module and an address of the cell where the currentfocus is located; and a second column number calculation module adaptedto calculate the column number of the cell of the electronic table intowhich the time interval should be written according to a judgment resultof the table item information judgment module and a start cell address.17. The system according to claim 14, between the writing module and thesending module, further comprising: an item information judgment moduleadapted to judge whether the item information exists in the systemtable; a formula judgment module adapted to judge whether a formula isincluded in the item information according to a judgment result of theitem information judgment module; and a formula generating moduleadapted to resolve the formula contained in the item information to bean item name, substitute the cell address where the line in which theitem name is located intersects the column respectively in which eachbasic period is located into the formula to generate a new formula, andwrite the new formula into the cell determined by the line where theitem name containing the formula is located and the column where eachbasic period is located.
 18. The system according to claim 13, betweenthe writing module and the sending module, further comprising: acalculation manner and position writing module adapted to writecalculation manner information for calculating the data object into theelectronic table and writing position information of the calculationresult data obtained after calculation.
 19. The system according toclaim 12, wherein the calculation module comprises: a statistic moduleadapted to transform the item name information and the basic periodinformation into electronic table address information, transform asummary formula into an electronic table formula indicated by celladdress information, and count item data.
 20. The system according toclaim 15, between the writing module and the sending module, furthercomprising: an item information judgment module adapted to judge whetherthe item information exists in the system table; a formula judgmentmodule adapted to judge whether a formula is included in the iteminformation according to a judgment result of the item informationjudgment module; and a formula generating module adapted to resolve theformula contained in the item information to be an item name, substitutethe cell address where the line in which the item name is locatedintersects the column respectively in which each basic period is locatedinto the formula to generate a new formula, and write the new formulainto the cell determined by the line where the item name containing theformula is located and the column where each basic period is located.